Harness The Future With Generative Ai For Data-Driven Retrospective Analysis